Q • moving average and weighted moving average forecasting technique (see examples on p.114-115 Examples 1 & 2). Follow same approach using your business as an example.
I have collected the sales data of the company Panache Inc. for the last two years and have applied the method of moving average in my data set. The following is the forecasted value of the data set after using the moving average: Month Actual Demand Forecast Demand January (2016) 25 February 23 March 28 April 26 25.3 May 27 25.7 June 27 27.0 July 25 26.7 August 21 26.3 September 18 24.3 October 14 21.3 November 12 17.7 December 18 14.7 January (2017) 28 14.7 February 27 19.3 March 24 24.3 April 25 26.3 May 23 25.3 June 22 24.0 July 28 23.3 August 29 24.3 September 14 26.3 October 15 23.7 November 16 19.3 December 12 15.0
